﻿CREATE TABLE [dbo].[admin_Audit] (
    [RecID]     BIGINT           IDENTITY (1, 1) NOT NULL,
    [UserId]    UNIQUEIDENTIFIER NOT NULL,
    [TableName] VARCHAR (50)     NOT NULL,
    [Operation] VARCHAR (10)     NOT NULL,
    [CampID]    BIGINT           NOT NULL,
    [Data]      DATETIME         CONSTRAINT [DF_admin_Audit_Data] DEFAULT (getdate()) NOT NULL,
    [CampIDStr] VARCHAR (150)    NULL,
    CONSTRAINT [PK_admin_Audit] PRIMARY KEY CLUSTERED ([RecID] ASC)
);

